This model dimension represents the Group Consolidation balance fact for transcations which are NOT of types 'CONSOLIDATED_BALANCE','CURR_EFFECT_OPENING','CURR_EFFECT_DURING_YEAR' and 'CURR_EFFECT_COUNTER_POST'. The dimension is based on the IFS Cloud fact FACT_CONSOL_BALANCE.
The dimension contains only one hierarchy used for browsing through the balance structure. The structure is based on the last consolidation period.
Sort Order of attributes Structure Node and Structure Node Sublevel are based on the definition of the Consolidation Structure in IFS Cloud. These attributes are displayed as Sort Order-Structure Node and Sort Order-Structure Node Sub Level respectively.
| Attribute | Description (where applicable) |
| Hierarchy | Level |
| ConsBalDetSHy | |
| Tot_Sort_Struct_Node_Code_Desc | |
| Sort_Struct_Sub_level_Code_Desc | |
| STRUCTURE_KEY | |
| BALANCE_VERSION_KEY |
| Model Name |
| Group Consolidation |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| CONSOLIDATED BALANCES DETAILS SHY | DIM_CONSOL_BALANCE_DETAIL_SHY | Data Mart |